How to Duplicate a Table in BigQuery

SQL Tutorial Home

In BigQuery you can duplicate a table, but you need to use a different table name. To duplicate the schema and content of a table just do:

create table Database_test_IB1.employee_new 
             as select * from Database_test_IB1.employee;

If you want to create a new table replicating the schema, but leaving the table empty, you can do:

create table Database_test_IB1.employee_new 
as select * from Database_test_IB1.employee limit 0;

IN THIS PAGE